package com.huanf.domain;

import java.io.Serializable;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import com.baomidou.mybatisplus.annotation.TableName;
/**
 * 用户信息表(ReadToMySQLVo)表实体类
 *
 * @author makejava
 * @since 2023-12-26 22:49:45
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("easy_poi")
public class ReadToMySQLVo implements Serializable {

    @Excel(name = "编号")//name属性值必须跟表格那边对应，这个zidingyi_id字段才能从Excel拿到值
    private String id;//字段名自定义就好，不需要跟表格那边一致。字段类型必须跟表格那边一致，不知道就写String类型

    @Excel(name = "姓名")
    private String name;

    @Excel(name = "生日",format = "yyyy-MM-dd HH:mm:ss")
    private String bir;

    //如果是图片，type属性值必须为2，表示图片类型。savePath表示从Excel读取出来的图片，要保存到哪个位置
    @Excel(name = "头像图片",type = 2,savePath = "E:\\桌面\\Java-Ready\\Excel-EasyPOI\\src\\main\\resources\\")
    private String avatar;

    @Excel(name = "年龄")
    private String age;

    @Excel(name = "爱好")
    private String hobby;

    @Excel(name = "身份证号")
    private String idCart;

    @Excel(name = "住址")
    private String address;
}
